#!/usr/bin/env python
# coding=utf-8
"""
@Author  : youjia - 卞志伟
@file    : pd索引切割.py
@contact : bianzhiwei@iyoujia.com
@time    : 2019-09-06 09:27 
@Desc    : 
@Software: PyCharm
"""
import os
import sys

# 当前文件的路径
pwd, filename = os.path.split(os.path.abspath(__file__))
# 当前文件的父路径
father_path = os.path.abspath(os.path.dirname(pwd) + os.path.sep + ".")
# 当前文件的前两级目录
grader_father = os.path.abspath(os.path.dirname(pwd) + os.path.sep + "..")
sys.path.append(pwd)
sys.path.append(father_path)
sys.path.append(grader_father)
import pandas as pd
from report_system.utils import df_util

sheet_df = pd.read_excel("/Users/youjia/work/youjia_project/report_system/report_files/0房源对账.xlsx")
# 307882222352901673 房源id
df = df_util.df_set_index(sheet_df, '房源id')
# city_sheet_df = df.ix["307882222352901673"].copy()
df = df[df.订单状态 == "房客取1消部分扣款"]
print(df)
